Role: ETL Informatica Consultant
Location: New York, NY(Onsite)
Job Type: Full Time
Job Description
- Knowledge of PL/SQL is Must with hands-on experience.
- Understanding the Business Requirements & ETL specification Document
- Extraction, Transformation and Loading (ETL) of data by using Informatica PC
- Designed various mappings for extracting data from various sources involving flat files and relational tables.
- Good Concept of Data warehouse to be available.
- Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
- Checked and tuned the performance of Informatica Mappings.
- Testing and maintaining of Informatica Mappings
- Resolving if any issues in transformations and mappings with the help of technical specifications.
- has context menu.